package com.kaiyun.sharding.mapper.provide;


import com.baomidou.mybatisplus.core.metadata.IPage;
import com.kaiyun.sharding.model.CourseBase;
import com.kaiyun.sharding.model.param.Course;

/**
 *
 * @author zhanNaifeng
 * @see
 * @since
 */
public class CourseBaseProvide {



    public String getList3(IPage<Course> page, Long userId){
        String sql="select name from t_course_base where user_id=#{userId} order by id desc";
        return sql;
    }

    public String getList4(IPage<Course> page, CourseBase base){
        String sql="select a.name,b.name userName from t_course_base a left join t_dictionary b on a.user_id=b.user_id" +
            " where a.name like  concat('%',#{base.name},'%')  order by a.id desc";
        return sql;
    }



}
